SELECT *, CASE WHEN `name` LIKE "poughkeepsie%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "poughkeepsie" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "poughkeepsie" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "poughkeepsie" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("poughkeepsie") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,350,0008 Balmoral CtPoughkeepsie NY 12603View Listing
$1,350,00067 S Randolph AvePoughkeepsie NY 12601View Listing
$1,195,00086 Victor DrPoughkeepsie NY 12603View Listing
$1,125,77710 Parasol RdgPoughkeepsie NY 12603View Listing
$995,00045 Mollys WayPoughkeepsie NY 12601View Listing
$850,00016 Garfield PlPoughkeepsie NY 12601View Listing
$799,000119 Kingwood ParkPoughkeepsie NY 12601View Listing
$749,900159 Rombout RdPoughkeepsie NY 12603View Listing
$749,900110 Livingston StPoughkeepsie NY 12601View Listing
$739,00065 Old Field RdPoughkeepsie NY 12603View Listing
$719,00092 Rochdale RdPoughkeepsie NY 12603View Listing
$700,000931 Dutchess TpkePoughkeepsie NY 12603View Listing
$699,900243 Ridgeline DrPoughkeepsie NY 12603View Listing
$699,00096 Dutchess Hill RdPoughkeepsie NY 12601View Listing
$699,00038 Point StPoughkeepsie NY 12590View Listing
$695,5008 Michaels LnPoughkeepsie NY 12603View Listing
$695,00099 Hooker AvePoughkeepsie NY 12601View Listing
$690,00048 Edwin RdPoughkeepsie NY 12603View Listing
$675,0009 Dartmouth Dr Lot 84Poughkeepsie NY 12603View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 1:37:46 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Ranch
Single Family
